package com.smile.ye.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.smile.ye.data.vo.StoreVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface StoreMapper extends BaseMapper<StoreVo> {
    @Select("SELECT * FROM smile_store t inner join smile_staff s on s.username=${username} and s.tenant = t.tenant")
    public List<StoreVo> queryStore(String username);
}
